REM  SQL scripts for Chapter 13 of ORACLE8 DBA Handbook by Kevin Loney.
REM  See www.osborne.com for updates to these scripts.


LOC =(DESCRIPTION=
      (ADDRESS=
            (PROTOCOL=TCP)
            (HOST=HQ)
            (PORT=1521))
      (CONNECT DATA=
            (SID=loc)))


> sqlplus hr/puffinstuff@LOC;


LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= loc.world)
        )
   ) 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = loc)
      (ORACLE_HOME = /orasw/app/oracle/product/8.0.3.1)
    )
  )


LOC =(DESCRIPTION=
      (ADDRESS=
            (COMMUNITY=TCP.HQ.COMPANY)
            (PROTOCOL=TCP)
            (HOST=HQ)
            (PORT=1521))
      (CONNECT DATA=
            (SID=loc)))


cmctl start cman


create database link HR_LINK
connect to HR identified by PUFFINSTUFF
using 'loc';


create public database link HR_LINK
connect to HR identified by PUFFINSTUFF
using 'loc';


create view LOCAL_EMPLOYEE_VIEW
as
select * from EMPLOYEE@HR_LINK
where Office='ANNAPOLIS';

create public synonym EMPLOYEE for EMPLOYEE@HR_LINK;


create database link HR_LINK
connect to HR identified by PUFFINSTUFF
using 'loc';

create table EMPLOYEE
as
select * from EMPLOYEE@HR_LINK;


copy from
remote_username/remote_password@service_name
to
username/password@service_name
[append|create|insert|replace]
TABLE_NAME
using subquery;

set copycommit 1
set arraysize 1000
copy from HR/PUFFINSTUFF@loc -
create EMPLOYEE -
using -
select * from EMPLOYEE


LOC =(DESCRIPTION=
      (SDU=2048)
      (TDU=2048)
      (ADDRESS=
            (PROTOCOL=TCP)
            (HOST=HQ)
            (PORT=1521))
      (CONNECT DATA=
            (SID=loc)))


LISTENER =
  (ADDRESS_LIST =
        (ADDRESS=
          (PROTOCOL=IPC)
          (KEY= loc.world)
        )
   ) 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SDU=2048)
      (TDU=2048)
      (SID_NAME = loc)
      (ORACLE_HOME = /orasw/app/oracle/product/8.0.3.1)
    )
  )

